USE [ElmuebApp]
GO
/****** Object:  Table [dbo].[pvEmisor]    Script Date: 07/17/2011 02:35:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
DROP TABLE PVEMISOR
GO
CREATE TABLE [dbo].[pvEmisor](
	[razonSocial] [varchar](100) NULL,
	[rfc] [varchar](20) NULL,
	[numExterior] [varchar](20) NULL,
	[numInterior] [varchar](20) NULL,
	[calle] [varchar](50) NULL,
	[colonia] [varchar](50) NULL,
	[cp] [varchar](20) NULL,
	[estado] [varchar](50) NULL,
	[localidad] [varchar](50) NULL,
	[municipio] [varchar](50) NULL,
	[pais] [varchar](10) NULL,
	[email] [varchar](50) NULL,
	[telefono] [varchar](20) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

INSERT INTO PVEMISOR (razonSocial,rfc,numExterior,numInterior,calle,colonia,cp,estado,localidad,municipio,pais,email,telefono) 
		VALUEs ('Operadora Mexicana del Hogar S.A. de C.V.','OMH071221FM4','431','','Francisco Zarco','Sagrada Familia','44200','Jalisco','Guadalajara','Guadalajara','Mexico','ibuenrostro@electromuebles.com','3336822082')
GO
